Captain Jack schrieb:

> SELECT C.Name, U.UserName
> FROM tblClients AS C
> OUTER JOIN tblUsers AS U ON U.UserId = C.LastEditUserID
> 
> In that case, the column LastEditUserID is zero (another way of logically 
> saying Null, I s'pose) when the client row is new and has never been edited. 
> I do that so that in that query I always get the client data, with the user 
> name being optional.

In theory, you'd solve this by adding another entry to tblUsers with 
default values to use for new clients.

Post a reply to this message